﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="List.aspx.vb" Inherits="WebApplication1.SkinCareList" %>
 
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
   
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
        <br />
        <br />
        <br />
      <asp:Button ID="AddNew" runat="server" Height="32px" Text="Add New" 
              Width="128px" />
        <br />
        <br />
          <div>
        <asp:Button ID="Button1" runat="server" Text="Add New" 
            PostBackUrl="~/addNewskincare.aspx" />
                   <br />
                   <br />
                   <asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1">
        <ItemTemplate>
       <a href="List.aspx?Tagname=<%#Eval("TagName")%>">
       <%#Eval("TagName")%>
       </a> | 
         </ItemTemplate>
</asp:Repeater>
<a href="List.aspx">Show all</a>
<br />
<br />
      <asp:GridView ID="GridView1" runat="server" AllowSorting="True" 
            AutoGenerateColumns="False" CssClass="gv"
            DataKeyNames="ID">
            <Columns>
                <asp:HyperLinkField DataNavigateUrlFields="ID" 
                    DataNavigateUrlFormatString="details.aspx?ID={0}"  SortExpression="Skin_Care_Center_Name"
                    DataTextField="Skin_Care_Center_Name" HeaderText="SkinCareCenterName" />
                <asp:BoundField DataField="Postcode" 
                    HeaderText="Postcode" SortExpression="Postcode" />
                <asp:HyperLinkField DataNavigateUrlFields="Website" SortExpression="Website"
                    DataNavigateUrlFormatString="{0}" DataTextField="Website" 
                    HeaderText="Website" />
                <asp:BoundField DataField="Phone_Number" HeaderText="Phone_Number" 
                    SortExpression="Phone_Number" >
                <ControlStyle CssClass="phone number" ForeColor="Red" />
                </asp:BoundField>
                <asp:ImageField DataImageUrlField="Care_Center_Images" HeaderText="Thumbnail">
                    <ControlStyle CssClass="skincare" Height="200px" Width="200px" />
                </asp:ImageField>
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SkinDataSource" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SkinConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:SkinConnectionString.ProviderName %>" 
            SelectCommand="SELECT [ID], [Skin Care Center Name] AS Skin_Care_Center_Name, [Postcode], [Website], [Care Center Images] AS Care_Center_Images, [Phone Number] AS Phone_Number FROM [skin care]">
        </asp:SqlDataSource>
              <br />
        <asp:SqlDataSource ID="SkinDataSource0" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SkinConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:SkinConnectionString.ProviderName %>" 
            
                  SelectCommand="SELECT [Skin Care Center Name] AS Skin_Care_Center_Name, [Tagname], [ID], [Postcode], [Skin Care Physician] AS Skin_Care_Physician, [Physician Details] AS Physician_Details, [Website], [Phone Number] AS Phone_Number, [Care Center Images] AS Care_Center_Images, [Consult fee] AS Consult_fee, [Rating Stars] AS Rating_Stars FROM [tagsQueryview] WHERE ([Tagname] = ?)">
            <SelectParameters>
                <asp:QueryStringParameter Name="Tagname" QueryStringField="Tagname" 
                    Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
        <br />
        <br />
        <br />

          The best skincare Tips Online
     
          </div>
          <br />
          <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
              ConnectionString="<%$ ConnectionStrings:SkinConnectionString %>" 
              ProviderName="<%$ ConnectionStrings:SkinConnectionString.ProviderName %>" 
              SelectCommand="SELECT [ID], [Tagname] FROM [Tags]"></asp:SqlDataSource>
              <br />
             <br />
            <br />
  
          <asp:TextBox ID="t1" runat="server" Height="28px" Width="276px"></asp:TextBox>
          <asp:Button ID="search" runat="server" Text="search" />
        <br />
        <br />
        <br />
        Rss feed <asp:ImageButton ID="ImageButton1" ImageUrl="pictures/rss_logo.jpg" 
            Width="50px" Height="39px"  runat="server" />
      
</asp:Content>

